TYPE=VIEW
query=select `op`.`nid` AS `nid`,`o`.`uid` AS `uid`,count(`o`.`order_id`) AS `order_count`,avg(`op`.`qty`) AS `avg_qty`,sum(`op`.`qty`) AS `sum_qty`,max(`op`.`qty`) AS `max_qty`,min(`op`.`qty`) AS `min_qty` from (`coursebay`.`uc_order_products` `op` join `coursebay`.`uc_orders` `o`) where (`op`.`order_id` = `o`.`order_id`) group by `o`.`uid`,`op`.`nid` order by `o`.`uid`,`op`.`nid`
md5=db2b01d47d58e71237d04970b8fb1342
updatable=0
algorithm=0
definer_user=solvedho
definer_host=localhost
suid=1
with_check_option=0
timestamp=2011-07-14 04:22:39
create-version=1
source=select `op`.`nid` AS `nid`,`o`.`uid` AS `uid`,count(`o`.`order_id`) AS `order_count`,avg(`op`.`qty`) AS `avg_qty`,sum(`op`.`qty`) AS `sum_qty`,max(`op`.`qty`) AS `max_qty`,min(`op`.`qty`) AS `min_qty` from (`uc_order_products` `op` join `uc_orders` `o`) where (`op`.`order_id` = `o`.`order_id`) group by `o`.`uid`,`op`.`nid` order by `o`.`uid`,`op`.`nid`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `op`.`nid` AS `nid`,`o`.`uid` AS `uid`,count(`o`.`order_id`) AS `order_count`,avg(`op`.`qty`) AS `avg_qty`,sum(`op`.`qty`) AS `sum_qty`,max(`op`.`qty`) AS `max_qty`,min(`op`.`qty`) AS `min_qty` from (`coursebay`.`uc_order_products` `op` join `coursebay`.`uc_orders` `o`) where (`op`.`order_id` = `o`.`order_id`) group by `o`.`uid`,`op`.`nid` order by `o`.`uid`,`op`.`nid`
